UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ip04IFYpXN0JDPSJ8VPSGzEoua4JNQg7r+O6WMElC3Q=' 
WHERE 
  key_id = 'fca27c4501e6a5cba44a8a0d5b5a5473688639049873831c195578b24b4a41b4' 
  AND (
    token = 'ip04IFYpXN0JDPSJ8VPSGzEoua4JNQg7r+O6WMElC3Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044