UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4j4yIVCMJBNk9mA5PjqWHN1uxoBgc+9MJj34E4fac3o='
WHERE
key_id = '27fe25b8221a8dd1a618eddfa7b6043b24d004587b3afb9bccebb883ccf91eef'
AND (
token = '4j4yIVCMJBNk9mA5PjqWHN1uxoBgc+9MJj34E4fac3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)