UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmja4zgvJPT+p36Jre/u+lAnmPxC48wDfUdVBj/3ueE='
WHERE
key_id = 'c8f34804e706db4943b86ffc417a6933863a3cafc38c80daba8cd6031fafe78b'
AND (
token = 'pmja4zgvJPT+p36Jre/u+lAnmPxC48wDfUdVBj/3ueE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)