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