UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '13HE9fHqEjEw1Vau2bHmAbArcuHEm7lCOLZESdnZlbw='
WHERE
key_id = '7a5fdf243bd96f3326ccd61f63cd6fe29035c740be3be15912d3bc0ae7e00302'
AND (
token = '13HE9fHqEjEw1Vau2bHmAbArcuHEm7lCOLZESdnZlbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)