UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q/7SsxGiVF2+hObU4CT+P7q8trMLhwuoQM4jICfspj0='
WHERE
key_id = '6099a07bac24f6fe2d02355f1dbca1a07745dce993933101edbc4d0d787fe349'
AND (
token = 'q/7SsxGiVF2+hObU4CT+P7q8trMLhwuoQM4jICfspj0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)