UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtREfF4UrS3ZkhYO2mU5kgyDidQS3nDs/JBF+VEPk7c='
WHERE
key_id = 'ca8ced28c2e2c5b06c85630cf450607d106eb83c1fb48b4c03c89e0e85aa7067'
AND (
token = 'XtREfF4UrS3ZkhYO2mU5kgyDidQS3nDs/JBF+VEPk7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)