UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TKHwYw68XIgrnOOm5p/lxqH9Cv3w0MEMohRQ3ZEbZV4='
WHERE
key_id = 'a1e97e6771f3664ccf9cc0549da6a5ff42d6e7e126f533d9e28a6bcafcce9583'
AND (
token = 'TKHwYw68XIgrnOOm5p/lxqH9Cv3w0MEMohRQ3ZEbZV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)