UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FrLvYuneU9FI9jaP9UtyfNoZ72c4HA7QIO/wWUfTrmY='
WHERE
key_id = 'aa7a2f00eca6b70c8167faeacd20f4d5e914e3e146ad8b1dfdf5827a8bc0d360'
AND (
token = 'FrLvYuneU9FI9jaP9UtyfNoZ72c4HA7QIO/wWUfTrmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)