UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g6pzr/Z/pm8BZQ0m9PqsY8x1l01yIheNCMHFQkn9Mfs='
WHERE
key_id = 'a1d719b169238cc2178a77f19c04d67bb5b29de842cf9f91f7f2995c27a73cab'
AND (
token = 'g6pzr/Z/pm8BZQ0m9PqsY8x1l01yIheNCMHFQkn9Mfs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)