UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R1KwFU4zEL1suAkK6+LUi62VxofZESzBf1DNTPIMHP8='
WHERE
key_id = 'cad0fadb810e8563946588699aac117585faecd32e23a212fab9dd747bbab2f4'
AND (
token = 'R1KwFU4zEL1suAkK6+LUi62VxofZESzBf1DNTPIMHP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)