UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZvkLu/SU6jvyOtCVssFE71NaW9Y8gDAGgj3I5zX3S88='
WHERE
key_id = '08027c6d219bc112b1c454e26bdcfb68698b625efb6ad2eea5ade9b400acf96d'
AND (
token = 'ZvkLu/SU6jvyOtCVssFE71NaW9Y8gDAGgj3I5zX3S88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)