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