UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bKAde0p0aGxdwz5dcdSHv1bOzmBZ4yzVq2VKXUuVj2E=' 
WHERE 
  key_id = '1341bd76bc2c44caf44a82f0a74cd3fb0626ec95c4a1ddbf96a1307231d93d58' 
  AND (
    token = 'bKAde0p0aGxdwz5dcdSHv1bOzmBZ4yzVq2VKXUuVj2E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00054