UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyWYv2zh77SJ8EZXf1ggXKyuUzCv/4W1C9xd5VNzxNw='
WHERE
key_id = 'c8c01c849998d8bf197a1c395d17d004fcbdc983dd67f23f4c291df3787195e0'
AND (
token = 'ZyWYv2zh77SJ8EZXf1ggXKyuUzCv/4W1C9xd5VNzxNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)