UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/JUW21UmsIau2wU+tEF+AgJzm5zaml9Nwl+2uQ4RFZw=' 
WHERE 
  key_id = '9b1ceac615067939beae717664dab30bc75214651c2beb09b82fba927fb2dc4a' 
  AND (
    token = '/JUW21UmsIau2wU+tEF+AgJzm5zaml9Nwl+2uQ4RFZw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040