UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'miax7DIg0qVe05NYOqO/dfr1H+uE3VgbE7rsP29FUjw=' 
WHERE 
  key_id = '23f6367982479321626ba0f27a9294b988981fe0ff0ce8b74e52a51c8d994e44' 
  AND (
    token = 'miax7DIg0qVe05NYOqO/dfr1H+uE3VgbE7rsP29FUjw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00045