UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6/NeMyoJK82Cxj30RSKLAaVVxQPfAzOeGdLdvUx99+s='
WHERE
key_id = '3f27171930847d012f8696bd4fe9081bb13b4368cd4ffdb0fbb6504a0ea93839'
AND (
token = '6/NeMyoJK82Cxj30RSKLAaVVxQPfAzOeGdLdvUx99+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)