UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZbjebuYxkSO17A+cNE97uk05ONHOX7XrE57DzbRIG4c=' 
WHERE 
  key_id = '073c3d3adf62dabd49bbb49f8ad0e4f58cbd90cdad61e4ff3530558f4504f138' 
  AND (
    token = 'ZbjebuYxkSO17A+cNE97uk05ONHOX7XrE57DzbRIG4c=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036