UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'noA+Z9o4WT0xiOZT+9q6aV32J/qfqGxCrDB+qxWGp5A='
WHERE
key_id = '8a143dff59716aaaf75ce68e29c627d1a393ee96e41e1484c97153c5a80ca936'
AND (
token = 'noA+Z9o4WT0xiOZT+9q6aV32J/qfqGxCrDB+qxWGp5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)