UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pU2sMAjI3kEBDgCryqcs0/9pIO0nBIMdGMlk9CI0ew='
WHERE
key_id = '1dfd672e3617531ec010d851ed44a28a886fd56dbcf9c2aea356031a34def2af'
AND (
token = '9pU2sMAjI3kEBDgCryqcs0/9pIO0nBIMdGMlk9CI0ew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)