UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CX1+pHhS4Cv4+UqTpTlUNrI51EJuIyTDiPJ5gM4Rvj8='
WHERE
key_id = '9435d1505827528d8b58858f70410e650d6e26a7c5e747a5238d964d4e39c187'
AND (
token = 'CX1+pHhS4Cv4+UqTpTlUNrI51EJuIyTDiPJ5gM4Rvj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)