UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nvz8k8EhLn3eUuaa1B5gjmQcbvTF/fIrIfE+rt8MzHk=' 
WHERE 
  key_id = 'be60ee4ca401e39f0ea4de9112c06c68002db747a15fe6823c37f373348df9cd' 
  AND (
    token = 'nvz8k8EhLn3eUuaa1B5gjmQcbvTF/fIrIfE+rt8MzHk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020