UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zTolcjV68UzsQJjeiPq7xNTOBDOMNq/MCVgdU9mVGjo='
WHERE
key_id = 'd9b865fe756f72ff4b3364a6919622f6e892d19366cf27b89099ca04a8a0ecc9'
AND (
token = 'zTolcjV68UzsQJjeiPq7xNTOBDOMNq/MCVgdU9mVGjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)