UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'od1qRpIBOm1f+IeYXB0kiymPEfR+LkyxR2eeK7WPJVU=' 
WHERE 
  key_id = '5a9ad3c876c848b7a12753d4b56229b7a3274c0ebf0220d585272443cf9c1c14' 
  AND (
    token = 'od1qRpIBOm1f+IeYXB0kiymPEfR+LkyxR2eeK7WPJVU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025