UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XV/8r7lV4bN9jNBoUBelk8cY08A3jfvKTHBmk3EmOw4='
WHERE
key_id = 'f1e82163a6bfd17a245ea8d4ff4a87e05d3047fbef77dd9a318a020a1d744c9e'
AND (
token = 'XV/8r7lV4bN9jNBoUBelk8cY08A3jfvKTHBmk3EmOw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)