UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3NHG9nbvWoBNndgQibfQ1jz80YuHaToxR2niPgVcsiM='
WHERE
key_id = 'ecc920a6ce3b80d0821bff3175872a5147fc66378307f6b0fb8b4fbd782b7cb0'
AND (
token = '3NHG9nbvWoBNndgQibfQ1jz80YuHaToxR2niPgVcsiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)