UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXM/nZB83VsmT0aCOE2YZN0QHbDqNfNRLN7vHW3BXO8='
WHERE
key_id = '5528471e60d110485d7040c86ae4ea5e070e325f6593083bf70a4bf3cd95108d'
AND (
token = 'zXM/nZB83VsmT0aCOE2YZN0QHbDqNfNRLN7vHW3BXO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)