UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5U14YBmY4BTAl5mTX+u1v/cGMD28x3XQiRA/p4b5qsM='
WHERE
key_id = '900af34c140449fb123b3b8ee177c24faf356958f53c7f2d96fc335fb991ebb3'
AND (
token = '5U14YBmY4BTAl5mTX+u1v/cGMD28x3XQiRA/p4b5qsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)