UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMd5smsHWk7mLknq4IlopUy9q3/u5hV1gFLcIuAs1sA='
WHERE
key_id = 'e51bb69491ee3296e1217c6767759c45f85ce4826e664dc909c039f25861a0f6'
AND (
token = 'BMd5smsHWk7mLknq4IlopUy9q3/u5hV1gFLcIuAs1sA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)