UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'JZeyLE05MH+IXZuTB3f61/iCZbl9Uzc+VVkbUeUm8f4=' 
WHERE 
  key_id = 'd05d79064362d66d6d3ae7ebc472da63e6a0c4cc22bf01ec4ce0881c94634e45' 
  AND (
    token = 'JZeyLE05MH+IXZuTB3f61/iCZbl9Uzc+VVkbUeUm8f4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034