UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x0LlPzRogjTh6GTNHjRQnbXnZI8JzAkRPSf1lqdrliI='
WHERE
key_id = 'd197e1f2933d7956700ce22453d2082c9125f11f61e939092e392e1a3775e35c'
AND (
token = 'x0LlPzRogjTh6GTNHjRQnbXnZI8JzAkRPSf1lqdrliI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)