UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfHUUuyR0hpS5fycdbHtb5AG4SRoZxvoeqoyPnaoTGA='
WHERE
key_id = 'a0209f8361d476651785f301e47473f07130c06f54de838a0a2fd4aaeff6a56a'
AND (
token = 'zfHUUuyR0hpS5fycdbHtb5AG4SRoZxvoeqoyPnaoTGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)