UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgQbDDWqQIZxrYqPCHoTypTc3esQWONfbGMC/oqfOS0='
WHERE
key_id = '786c8d910b3e3116b83666414fb816c9bfc4f2babed84f4cf95a3bb17f4aa4f3'
AND (
token = 'zgQbDDWqQIZxrYqPCHoTypTc3esQWONfbGMC/oqfOS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)