UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oJEFXR12Qj6EXHIOCpNDgZHy5rvrvW7p/lVz2Ttu9g='
WHERE
key_id = '5f01fa7aea50157550334b19d4dd3fd4b9f08add1166fab289d55e2a2ad8591d'
AND (
token = '8oJEFXR12Qj6EXHIOCpNDgZHy5rvrvW7p/lVz2Ttu9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)