UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VaCVtcXVevr8VKmhPOWH6iBr00KMu1G2xHJR7xLUcEQ=' 
WHERE 
  key_id = '0ca3d0a9dd83d049de055a3e7d020e26dfa547f7c0f88b44cd11f2a89f6b996d' 
  AND (
    token = 'VaCVtcXVevr8VKmhPOWH6iBr00KMu1G2xHJR7xLUcEQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024