UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ium+csU4N3S3iguyOEmimj0yDzUhXuAcQaE+xCrL8F4='
WHERE
key_id = 'e0f5a1d8e6be82706d0a997c69f39dfb97df880e7b13442ef7d0a40f5bc7be90'
AND (
token = 'Ium+csU4N3S3iguyOEmimj0yDzUhXuAcQaE+xCrL8F4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)