UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o/iVmLPc1dtYVBPdKDo/aR+CODZfMsfe28QBIG1kurg='
WHERE
key_id = 'c8fddf8063810df77b3e5dac77c62d49c808992c075877e64547ea44c03f6231'
AND (
token = 'o/iVmLPc1dtYVBPdKDo/aR+CODZfMsfe28QBIG1kurg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)