UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ZWdcYB7CPjFVj0bgjXJTJ5QuIGlmJr3nw5F+aaAL4c='
WHERE
key_id = '41c8e8d50dd820b30e305881ca66a6170c83a3a00d74e1547a542b5614f8a330'
AND (
token = '5ZWdcYB7CPjFVj0bgjXJTJ5QuIGlmJr3nw5F+aaAL4c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)