UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+ccv0B7XSyaG1of1CTxKNsIHzdzI1tLHtWw7P3z4vB4='
WHERE
key_id = 'd596733402c4942ed652f7541283555a292e2090584e1b3b9da3382d274a12f8'
AND (
token = '+ccv0B7XSyaG1of1CTxKNsIHzdzI1tLHtWw7P3z4vB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)