UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'q7bdQuhq8mI2cH6yMn6I01Xd0lF/wP7c3JNxK1AerfE=' 
WHERE 
  key_id = 'a5cc024205e06a047565429ab1c8c08e2fb29e342b01872a96624d50f8182360' 
  AND (
    token = 'q7bdQuhq8mI2cH6yMn6I01Xd0lF/wP7c3JNxK1AerfE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019