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